﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/Master.Master" AutoEventWireup="true"
    CodeBehind="wFrmPronosticoImportacionActualizar.aspx.cs" Inherits="Crosland.Automotriz.Web.Repuestos.wFrmPronosticoImportacionActualizar" %>

<%@ Register Assembly="DevExpress.Web.v13.1, Version=13.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxRoundPanel" TagPrefix="dx" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
    Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<%@ Register Assembly="DevExpress.Web.v13.1, Version=13.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxPanel" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.v13.1, Version=13.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxPopupControl" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.v13.1, Version=13.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxUploadControl" TagPrefix="dx" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<%@ Register Assembly="DevExpress.Web.v13.1, Version=13.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.v13.1, Version=13.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.v13.1, Version=13.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxGridView.Export" TagPrefix="dx" %>
<asp:Content ID="Content1" ContentPlaceHolderID="cphMain" runat="server">
    <script type="text/javascript">
    // <![CDATA[



        function ShowAnalizar() {
            PopupMostrarAna.Show();

        }
        function MostrarDatos() {
            btnVerDetalle.DoClick();
        }
  
    // ]]> 
    </script>
    <script type="text/javascript">

        function url() {
            open('wFrmSituacionArticuloReport.aspx', 'NewWindow', 'top=0,left=0,width=1500,height=650,status=yes,resizable=yes,scrollbars=yes');
        }
    </script>
    <script type="text/javascript" language="javascript">
        function RegistrarTriggers(control) {
            Sys.WebForm.PageRequestManager.getInstance()._updateControls(['SubirExcel'], [], [control.id], 90);
        }


        function RegistrarTriggers2(control) {
            Sys.WebForm.PageRequestManager.getInstance()._updateControls(['UpdatePanel2'], [], [control.id], 90);
        }

    </script>
    <script type="text/javascript">
    // <![CDATA[
        function button1_Click(s, e) {
            if (dgDetallePedido.IsCustomizationWindowVisible())
                dgDetallePedido.HideCustomizationWindow();
            else
                dgDetallePedido.ShowCustomizationWindow();
            UpdateButtonText();
        }
        function grid_CustomizationWindowCloseUp(s, e) {
            UpdateButtonText();
        }
        function UpdateButtonText() {
            var text = dgDetallePedido.IsCustomizationWindowVisible() ? "Ocultar" : "Mostrar";
            text += " Campos";
            button1.SetText(text);
        }
    // ]]> 
    </script>
    <div class="main-header" style="width: 100%;">
        <div class="main-titulo" style="text-align: left">
            Actualización de pronósticos de importación&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
            <asp:Label ID="lblTitulo" runat="server"></asp:Label></div>
    </div>
    <table>
        <tr>
            <td class="filas2">
                <dx:ASPxButton ID="btnImportar" runat="server" Text="Exportar Pedidos" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                    CssPostfix="Office2010Blue" OnClick="btnFormatoExcel_Click" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                    Width="160px">
                    <Image Url="~/Images/excel16.gif">
                    </Image>
                    <Paddings Padding="4px" />
                </dx:ASPxButton>
            </td>
            <td  class="filas2">
                <dx:ASPxButton ID="btnexport" runat="server" Text="Exportar Excel" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                    CssPostfix="Office2010Blue" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                    OnClick="btnexport_Click" AutoPostBack="False" Width="160px">
                    <ClientSideEvents Click="function(s, e) {
	pcPedidoImportacion.Show();
}" />
                    <Image Url="~/Images/excel16.gif">
                    </Image>
                    <Paddings Padding="4px" />
                </dx:ASPxButton>
            </td>
            <td  class="filas2" >
                <dx:ASPxButton ID="cmdImportar" runat="server" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                    CssPostfix="Office2010Blue" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                    Text="Importar Excel" AutoPostBack="False" Width="160px">
                    <ClientSideEvents Click="function(s, e) {
	PopupImportar.Show();
}" />
                    <Image Url="~/Images/excel16.gif">
                    </Image>
                    <Paddings Padding="4px" />
                </dx:ASPxButton>
            </td>
            <td  class="filas2">
                <dx:ASPxButton ID="btnMostrarAnalisis" runat="server" Text="Analizar Cálculo" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                    CssPostfix="Office2010Blue" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                    Width="160px" OnClick="btnMostrar_Click" AutoPostBack="False">
                    <Image Url="~/Images/calculator_add.png">
                    </Image>
                    <Paddings Padding="4px" />
                </dx:ASPxButton>
            </td>
            <td  class="filas2">
                <dx:ASPxButton ID="btnSituacionItem" runat="server" Text="Situación de Item" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                    CssPostfix="Office2010Blue" OnClick="btnSituacionItem_Click" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                    Width="170px" AutoPostBack="False">
                    <Image Url="~/Images/BarChart.gif">
                    </Image>
                    <Paddings Padding="4px" />
                </dx:ASPxButton>
            </td>
            <td  class="filas2">
                <dx:ASPxButton ID="btnImportarArticulos" runat="server" Text="Importar artículos"
                    CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
                    SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css" Width="180px"
                    AutoPostBack="False">
                    <ClientSideEvents Click="function(s, e) {
	PC_ImportarArticulos.Show();
}" />
                    <Image Url="~/Images/excel16.gif">
                    </Image>
                    <Paddings Padding="4px" />
                </dx:ASPxButton>
            </td>
            <td  class="filas2">
                <dx:ASPxButton ID="btnsal" runat="server" Text="Salir" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                    CssPostfix="Office2010Blue" OnClick="btnsal_Click" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                    Width="100px" AutoPostBack="False">
                    <Image Url="~/Images/logout.png">
                    </Image>
                    <Paddings Padding="4px" />
                </dx:ASPxButton>
            </td>
        </tr>
    </table>
    <div class="content-form">
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
            <ContentTemplate>
                <div style="position: absolute; top: 220px; left: 700px">
                    <asp:UpdateProgress ID="UpdateProgress2" runat="server" AssociatedUpdatePanelID="UpdatePanel1">
                        <ProgressTemplate>
                            <img src="../Images/loading2.gif" style="width: 48px; height: 48px" />
                        </ProgressTemplate>
                    </asp:UpdateProgress>
                </div>
                <dx:ASPxGridView ID="dgDetallePedido" runat="server" AutoGenerateColumns="False"
                    CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
                    Width="100%" KeyFieldName="id_material" ClientInstanceName="dgDetallePedido"
                    OnRowUpdating="dgDetallePedido_RowUpdating" OnCustomUnboundColumnData="dgDetallePedido_CustomUnboundColumnData1">
                    <SettingsPager PageSize="17">
                    </SettingsPager>
                    <SettingsEditing EditFormColumnCount="1" Mode="PopupEditForm" PopupEditFormHeight="200px"
                        PopupEditFormHorizontalAlign="WindowCenter" PopupEditFormModal="True" PopupEditFormVerticalAlign="WindowCenter"
                        PopupEditFormWidth="400px" />
                    <Settings ShowFilterBar="Visible" ShowFilterRow="True" VerticalScrollableHeight="300"
                        ShowFilterRowMenu="True" />
                    <Columns>
                        <dx:GridViewCommandColumn VisibleIndex="0" FixedStyle="Left" Caption="Editar">
                            <EditButton Visible="True">
                            </EditButton>
                        </dx:GridViewCommandColumn>
                        <dx:GridViewDataTextColumn Caption="Nro_Pronóstico" FieldName="Nro_Pronostico" ReadOnly="True"
                            VisibleIndex="60" Visible="False">
                            <PropertiesTextEdit Height="1px" Width="1px">
                                <ReadOnlyStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                                    <Border BorderColor="White" />
                                </ReadOnlyStyle>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <Settings AllowDragDrop="False" AllowGroup="True" />
                            <EditFormSettings Visible="False" />
                            <EditCellStyle BackColor="White" ForeColor="White">
                                <Border BorderColor="White" />
                            </EditCellStyle>
                            <EditFormCaptionStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                            </EditFormCaptionStyle>
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Marca" FieldName="DES_MARCA" ReadOnly="True"
                            VisibleIndex="17">
                            <PropertiesTextEdit>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                                <Style BackColor="White">
                                            <Border BorderColor="White" />
                                        </Style>
                            </PropertiesTextEdit>
                            <EditFormSettings VisibleIndex="4" />
                            <HeaderStyle HorizontalAlign="Center" />
                            <CellStyle Font-Size="7pt" HorizontalAlign="Center">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="id_material" Visible="False" VisibleIndex="1"
                            ReadOnly="True">
                            <PropertiesTextEdit Width="1px" Height="2px">
                                <ReadOnlyStyle BackColor="White" ForeColor="White">
                                    <Border BorderColor="White" />
                                </ReadOnlyStyle>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                                <Style BackColor="White" ForeColor="White">
                                            <Border BorderColor="White" />
                                        </Style>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="True" />
                            <EditCellStyle BackColor="White" ForeColor="White">
                                <Border BorderColor="White" />
                            </EditCellStyle>
                            <EditFormCaptionStyle BackColor="White" ForeColor="White">
                            </EditFormCaptionStyle>
                            <CellStyle BackColor="White" Font-Size="6pt">
                                <Border BorderColor="White" />
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Modelo" VisibleIndex="4" FieldName="DES_MODELO"
                            Width="150px" ReadOnly="True">
                            <PropertiesTextEdit>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                                <Style BackColor="White">
                                            <Border BorderColor="White" />
                                        </Style>
                            </PropertiesTextEdit>
                            <EditFormSettings VisibleIndex="5" Visible="True" />
                            <EditFormSettings VisibleIndex="6" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Código" ReadOnly="True" VisibleIndex="2" FieldName="COD_MATERIAL"
                            FixedStyle="Left" Width="70px">
                            <PropertiesTextEdit>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                                <Style BackColor="White">
                                            <Border BorderColor="White" />
                                        </Style>
                            </PropertiesTextEdit>
                            <Settings AllowDragDrop="False" />
                            <EditFormSettings VisibleIndex="2" Visible="True" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Descripción" FieldName="DES_MATERIALES" ReadOnly="True"
                            VisibleIndex="3" Width="200px" FixedStyle="Left">
                            <PropertiesTextEdit Height="2px">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                                <Style BackColor="White">
                                            <Border BorderColor="White" />
                                        </Style>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="True" VisibleIndex="3" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Stock Actual (Unid)" ReadOnly="True" VisibleIndex="9"
                            FieldName="can_stock" Width="70px">
                            <PropertiesTextEdit DisplayFormatString="{0:N0}">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <EditFormCaptionStyle VerticalAlign="Middle">
                            </EditFormCaptionStyle>
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Stock + Tránsito $" FieldName="can_stock_mas_transito"
                            ReadOnly="True" VisibleIndex="18">
                            <PropertiesTextEdit DisplayFormatString="{0:N0}">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Prom. Vta.&lt;/br&gt; Diaria" 
                            FieldName="psd" ReadOnly="True"
                            VisibleIndex="19">
                            <PropertiesTextEdit DisplayFormatString="##,##0.00">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Stock (días)" ReadOnly="True" VisibleIndex="20"
                            FieldName="stk_dia">
                            <PropertiesTextEdit DisplayFormatString="{0:N0}" Height="1px" Width="1px">
                                <ReadOnlyStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                                    <Border BorderColor="White" />
                                </ReadOnlyStyle>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Stock $" ReadOnly="True" VisibleIndex="21" Visible="False"
                            FieldName="Stock_D">
                            <PropertiesTextEdit DisplayFormatString="{0:N0}" Height="1px" Width="1px">
                                <ReadOnlyStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                                    <Border BorderColor="White" />
                                </ReadOnlyStyle>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Tránsito FOB $" ReadOnly="True" VisibleIndex="22"
                            FieldName="imp_transito_fob">
                            <PropertiesTextEdit DisplayFormatString="##,##0.00" Height="1px" Width="1px">
                                <ReadOnlyStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                                    <Border BorderColor="White" />
                                </ReadOnlyStyle>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Stock + Tránsito $" FieldName="stock_mas_transito_d"
                            ReadOnly="True" VisibleIndex="26" Visible="False">
                            <PropertiesTextEdit DisplayFormatString="##,##0.00">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Stock Min" Visible="False" VisibleIndex="41"
                            FieldName="can_stock_min" ReadOnly="True">
                            <PropertiesTextEdit Height="1px" Width="1px" DisplayFormatString="{0:N0}">
                                <ReadOnlyStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                                    <Border BorderColor="White" />
                                </ReadOnlyStyle>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Cant. Sugerida" FieldName="cant_sugerida" ReadOnly="True"
                            VisibleIndex="12">
                            <PropertiesTextEdit DisplayFormatString="{0:N0}">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings VisibleIndex="8" Visible="False" />
                            <EditFormCaptionStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                                <Border BorderColor="White" />
                            </EditFormCaptionStyle>
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Cant. Real" FieldName="cant_sug_real" VisibleIndex="13"
                            ReadOnly="False" UnboundType="Integer">
                            <PropertiesTextEdit DisplayFormatString="{0:N0}" DisplayFormatInEditMode="True">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings VisibleIndex="6" CaptionLocation="Near" Visible="True" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="FOB $" FieldName="fob_me" ReadOnly="True" VisibleIndex="14"
                            Width="70px">
                            <PropertiesTextEdit DisplayFormatString="##,##0.00">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <EditFormCaptionStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                                <Border BorderColor="White" />
                            </EditFormCaptionStyle>
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Venta Unid.&lt;/br&gt; de periodo" 
                            FieldName="cant_vta" ReadOnly="True"
                            VisibleIndex="8" ToolTip="Venta unidades" Width="80px">
                            <PropertiesTextEdit DisplayFormatString="{0:N0}">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings VisibleIndex="13" Visible="False" />
                            <EditFormCaptionStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                                <Border BorderColor="White" />
                            </EditFormCaptionStyle>
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Ventas $" FieldName="imp_ventas" ReadOnly="True"
                            VisibleIndex="44" Visible="False">
                            <PropertiesTextEdit DisplayFormatString="##,##0.00">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <EditFormCaptionStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                            </EditFormCaptionStyle>
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Prom.Vta.&lt;/br&gt;Mensual" 
                            FieldName="psm" ReadOnly="True" VisibleIndex="7"
                            Width="60px">
                            <PropertiesTextEdit DisplayFormatString="##,##0.00">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Cant. No Atendida" FieldName="cant_no_Ate" ReadOnly="True"
                            Visible="False" VisibleIndex="45">
                            <PropertiesTextEdit DisplayFormatString="{0:N0}">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Cant. No Atendida $" FieldName="cant_no_Ate_d"
                            ReadOnly="True" VisibleIndex="48" Visible="False">
                            <PropertiesTextEdit DisplayFormatString="{0:N0}">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Rotación &lt;/br&gt;Inventario" 
                            FieldName="Rotacion" VisibleIndex="11"
                            ReadOnly="True" Width="80px">
                            <PropertiesTextEdit DisplayFormatString="{0:N0}">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Margen %" FieldName="margen_p" ReadOnly="True"
                            VisibleIndex="51" Visible="False">
                            <PropertiesTextEdit DisplayFormatString="##,##0.00">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Ind Trabajo" FieldName="IND_TRABAJADO" ReadOnly="True"
                            VisibleIndex="54" Visible="False">
                            <PropertiesTextEdit>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataDateColumn Caption="Fecha_Caducidad" FieldName="FECHA_CADUCIDAD"
                            ReadOnly="True" VisibleIndex="58" Visible="False">
                            <PropertiesDateEdit>
                                <CalendarProperties ClearButtonText="Vaciar" TodayButtonText="Hoy">
                                    <FastNavProperties CancelButtonText="Cancelar" OkButtonText="Aceptar" />
                                </CalendarProperties>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesDateEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataDateColumn>
                        <dx:GridViewDataTextColumn Caption="Total Pronóstico&lt;/br&gt;FOB $" 
                            VisibleIndex="15" FieldName="Total"
                            UnboundType="Decimal" SortIndex="0" SortOrder="Descending">
                            <PropertiesTextEdit DisplayFormatString="##,##0.00">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <EditFormCaptionStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                                <Border BorderColor="White" />
                            </EditFormCaptionStyle>
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="CUP $" FieldName="cup_d" VisibleIndex="62" Visible="False">
                            <PropertiesTextEdit>
                                <ReadOnlyStyle ForeColor="White" Font-Size="1pt">
                                    <Border BorderColor="White" />
                                </ReadOnlyStyle>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="can_transito" VisibleIndex="10" Caption="Tránsito Unid."
                            Width="80px">
                            <PropertiesTextEdit DisplayFormatString="##,##0.00">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                                <Style BackColor="White">
                                            <Border BorderColor="White" />
                                        </Style>
                            </PropertiesTextEdit>
                            <PropertiesTextEdit>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                                <Style BackColor="White">
                                            <Border BorderColor="White" />
                                        </Style>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <EditFormCaptionStyle VerticalAlign="Middle">
                            </EditFormCaptionStyle>
                            <HeaderStyle Font-Size="7pt" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="can_stock" Visible="False" VisibleIndex="23">
                            <PropertiesTextEdit DisplayFormatString="{0:N0}">
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                                <Style BackColor="White">
                                            <Border BorderColor="White" />
                                        </Style>
                            </PropertiesTextEdit>
                            <PropertiesTextEdit>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="TIPO_ABC" VisibleIndex="5" Caption="Tipo ABC"
                            Width="60px">
                            <PropertiesTextEdit>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <PropertiesTextEdit>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <HeaderStyle Font-Size="7pt" />
                            <CellStyle Font-Size="7pt" HorizontalAlign="Center">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="ID_MARCA" Visible="False" VisibleIndex="24">
                            <PropertiesTextEdit Height="1px" Width="1px">
                                <ReadOnlyStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                                    <Border BorderColor="White" />
                                </ReadOnlyStyle>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <EditFormCaptionStyle BackColor="White" Font-Size="1pt" ForeColor="White">
                                <Border BorderColor="White" />
                            </EditFormCaptionStyle>
                            <PropertiesTextEdit>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="COD_MARCA" Visible="False" VisibleIndex="56">
                            <PropertiesTextEdit>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <PropertiesTextEdit>
                                <ValidationSettings ErrorText="Valor inválido">
                                    <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                                </ValidationSettings>
                            </PropertiesTextEdit>
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Descrip. inglés" FieldName="DES_MATERIAL_INGLES"
                            VisibleIndex="64">
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Nro Rueda" FieldName="TIP_NUM_RUEDA" VisibleIndex="16">
                            <EditFormSettings Visible="False" />
                            <HeaderStyle HorizontalAlign="Center" />
                            <CellStyle Font-Size="7pt" HorizontalAlign="Center">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="DES_MATERIAL" Visible="False" VisibleIndex="25">
                            <EditFormSettings Visible="False" />
                            <CellStyle Font-Size="7pt">
                            </CellStyle>
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Tipo ABC &lt;/br&gt; cant." FieldName="TIPO_ABC_CAN"
                            VisibleIndex="6" Width="60px">
                            <EditFormSettings Visible="False" />
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Tipo pronóstico" FieldName="DES_CORTA" VisibleIndex="66">
                            <EditFormSettings Visible="False" />
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <Settings ShowFooter="true" />
                    <TotalSummary>
                        <dx:ASPxSummaryItem FieldName="Total" SummaryType="Sum" />
                    </TotalSummary>
                    <SettingsBehavior AllowFocusedRow="True" AllowSelectByRowClick="True" AllowSelectSingleRowOnly="True" />
                    <Settings ShowHorizontalScrollBar="True" />
                    <SettingsCustomizationWindow Enabled="True" PopupVerticalAlign="TopSides" />
                    <SettingsCustomizationWindow Height="7px" />
                    <Images SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css">
                        <LoadingPanelOnStatusBar Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                        </LoadingPanelOnStatusBar>
                        <LoadingPanel Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                        </LoadingPanel>
                    </Images>
                    <ImagesFilterControl>
                        <LoadingPanel Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                        </LoadingPanel>
                    </ImagesFilterControl>
                    <Styles CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue">
                        <Header ImageSpacing="5px" SortingImageSpacing="5px">
                        </Header>
                        <Cell VerticalAlign="Top">
                        </Cell>
                        <LoadingPanel ImageSpacing="5px">
                        </LoadingPanel>
                        <FilterRowMenuItem ForeColor="#0070DF">
                        </FilterRowMenuItem>
                    </Styles>
                    <StylesPager>
                        <PageNumber ForeColor="#3E4846">
                        </PageNumber>
                        <Summary ForeColor="#1E395B">
                        </Summary>
                    </StylesPager>
                    <StylesEditors ButtonEditCellSpacing="0">
                        <ProgressBar Height="21px">
                        </ProgressBar>
                    </StylesEditors>
                </dx:ASPxGridView>
            </ContentTemplate>
        </asp:UpdatePanel>
        <br />
        <dx:ASPxGridView ID="gvExportarExcel2" runat="server" AutoGenerateColumns="False"
            ClientInstanceName="gvExportarExcel2" ClientVisible="False" KeyFieldName="COD_MATERIAL"
            CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue">
            <Columns>
                <dx:GridViewDataTextColumn Caption="Cod_Material" FieldName="COD_MATERIAL" VisibleIndex="1">
                    <PropertiesTextEdit>
                        <ValidationSettings ErrorText="Valor inválido">
                            <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                        </ValidationSettings>
                    </PropertiesTextEdit>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="Descripcion" FieldName="DES_MATERIAL" VisibleIndex="2">
                    <PropertiesTextEdit>
                        <ValidationSettings ErrorText="Valor inválido">
                            <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                        </ValidationSettings>
                    </PropertiesTextEdit>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="Marca" FieldName="DES_MARCA" VisibleIndex="3">
                    <PropertiesTextEdit>
                        <ValidationSettings ErrorText="Valor inválido">
                            <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                        </ValidationSettings>
                    </PropertiesTextEdit>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="Modelo" FieldName="DES_MODELO" VisibleIndex="4">
                    <PropertiesTextEdit>
                        <ValidationSettings ErrorText="Valor inválido">
                            <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                        </ValidationSettings>
                    </PropertiesTextEdit>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="Cant_Sugerida" FieldName="cant_sugerida" VisibleIndex="5">
                    <PropertiesTextEdit DisplayFormatString="{0:N0}">
                        <ValidationSettings ErrorText="Valor inválido">
                            <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                        </ValidationSettings>
                    </PropertiesTextEdit>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="Cant_Sug_Real" FieldName="cant_sug_real" VisibleIndex="6">
                    <PropertiesTextEdit DisplayFormatString="{0:N0}">
                        <ValidationSettings ErrorText="Valor inválido">
                            <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                        </ValidationSettings>
                    </PropertiesTextEdit>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="can_stock" FieldName="can_stock" VisibleIndex="7">
                    <PropertiesTextEdit DisplayFormatString="{0:N0}">
                        <ValidationSettings ErrorText="Valor inválido">
                            <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                        </ValidationSettings>
                    </PropertiesTextEdit>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="can_transito" FieldName="can_transito" VisibleIndex="8">
                    <PropertiesTextEdit>
                        <ValidationSettings ErrorText="Valor inválido">
                            <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                        </ValidationSettings>
                    </PropertiesTextEdit>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="Cant_Vendida" FieldName="cant_vta" VisibleIndex="9">
                    <PropertiesTextEdit DisplayFormatString="##,##0.00">
                        <ValidationSettings ErrorText="Valor inválido">
                            <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                        </ValidationSettings>
                    </PropertiesTextEdit>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="Imp_Ventas" FieldName="imp_ventas" VisibleIndex="10">
                    <PropertiesTextEdit DisplayFormatString="##,##0.00">
                        <ValidationSettings ErrorText="Valor inválido">
                            <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                        </ValidationSettings>
                    </PropertiesTextEdit>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="Fecha_Caducidad" FieldName="FECHA_CADUCIDAD"
                    VisibleIndex="11">
                    <PropertiesTextEdit>
                        <ValidationSettings ErrorText="Valor inválido">
                            <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                        </ValidationSettings>
                    </PropertiesTextEdit>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="Nro_Pronostico" FieldName="Nro_Pronostico" VisibleIndex="12">
                    <PropertiesTextEdit>
                        <ValidationSettings ErrorText="Valor inválido">
                            <RegularExpression ErrorText="Falló la validación de expresión Regular" />
                        </ValidationSettings>
                    </PropertiesTextEdit>
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="id_material" VisibleIndex="0">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="FOB $" FieldName="fob_me" VisibleIndex="13">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="Tipo ABC" FieldName="TIPO_ABC" VisibleIndex="14">
                </dx:GridViewDataTextColumn>
            </Columns>
            <SettingsPager PageSize="1000">
            </SettingsPager>
            <Images SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css">
                <LoadingPanelOnStatusBar Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                </LoadingPanelOnStatusBar>
                <LoadingPanel Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                </LoadingPanel>
            </Images>
            <ImagesFilterControl>
                <LoadingPanel Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                </LoadingPanel>
            </ImagesFilterControl>
            <Styles CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue">
                <Header ImageSpacing="5px" SortingImageSpacing="5px">
                </Header>
                <LoadingPanel ImageSpacing="5px">
                </LoadingPanel>
            </Styles>
            <StylesPager>
                <PageNumber ForeColor="#3E4846">
                </PageNumber>
                <Summary ForeColor="#1E395B">
                </Summary>
            </StylesPager>
            <StylesEditors ButtonEditCellSpacing="0">
                <ProgressBar Height="21px">
                </ProgressBar>
            </StylesEditors>
        </dx:ASPxGridView>
        <dx:ASPxGridViewExporter ID="dgvExportar" runat="server" GridViewID="gvExportarExcel2">
        </dx:ASPxGridViewExporter>
        <dx:ASPxPopupControl ID="PopupMostrarAna" runat="server" Width="950px" ClientInstanceName="PopupMostrarAna"
            AllowDragging="True" CloseAction="CloseButton" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
            CssPostfix="Office2010Blue" EnableViewState="False" HeaderText="Analizar cálculo"
            Modal="True" PopupHorizontalAlign="WindowCenter" PopupVerticalAlign="WindowCenter"
            SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css" EnableHotTrack="False">
            <LoadingPanelImage Url="~/App_Themes/Office2010Blue/Web/Loading.gif">
            </LoadingPanelImage>
            <HeaderStyle>
                <Paddings PaddingLeft="7px" />
            </HeaderStyle>
            <LoadingPanelStyle ImageSpacing="5px">
            </LoadingPanelStyle>
            <ContentCollection>
                <dx:PopupControlContentControl runat="server" SupportsDisabledAttribute="True">
                    <table width="100%">
                        <tr>
                            <td>
                                <dx:ASPxGridView ID="dgPronostico" runat="server" Width="100%" AutoGenerateColumns="False"
                                    CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
                                    OnHtmlRowPrepared="dgPronostico_HtmlRowPrepared" OnAfterPerformCallback="dgPronostico_AfterPerformCallback">
                                    <Columns>
                                        <dx:GridViewDataTextColumn Caption="Año" FieldName="NUM_ANO" ShowInCustomizationForm="True"
                                            VisibleIndex="0">
                                            <HeaderStyle HorizontalAlign="Center" />
                                            <CellStyle HorizontalAlign="Center">
                                            </CellStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Mes" FieldName="MES" ShowInCustomizationForm="True"
                                            VisibleIndex="1">
                                            <HeaderStyle HorizontalAlign="Center" />
                                            <CellStyle HorizontalAlign="Center">
                                            </CellStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Cant.Venta" FieldName="CANT_VENTA" ShowInCustomizationForm="True"
                                            VisibleIndex="2">
                                            <PropertiesTextEdit DisplayFormatString="##,##0.00">
                                            </PropertiesTextEdit>
                                            <HeaderStyle HorizontalAlign="Center" />
                                            <CellStyle HorizontalAlign="Center">
                                            </CellStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Venta $" FieldName="IMP_VENTA_D" ShowInCustomizationForm="True"
                                            VisibleIndex="3">
                                            <PropertiesTextEdit DisplayFormatString="##,##0.00">
                                            </PropertiesTextEdit>
                                            <HeaderStyle HorizontalAlign="Center" />
                                            <CellStyle HorizontalAlign="Center">
                                            </CellStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Venta S/." FieldName="IMP_VENTA_S" ShowInCustomizationForm="True"
                                            VisibleIndex="4">
                                            <PropertiesTextEdit DisplayFormatString="##,##0.00">
                                            </PropertiesTextEdit>
                                            <HeaderStyle HorizontalAlign="Center" />
                                            <CellStyle HorizontalAlign="Center">
                                            </CellStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Cant.Stock &lt;/br&gt;disponible" 
                                            FieldName="CANT_STOCK" ShowInCustomizationForm="True"
                                            VisibleIndex="5">
                                            <PropertiesTextEdit DisplayFormatString="##,##0.00">
                                            </PropertiesTextEdit>
                                            <HeaderStyle HorizontalAlign="Center" />
                                            <CellStyle HorizontalAlign="Center">
                                            </CellStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Máximo" FieldName="IND_MAX" ShowInCustomizationForm="True"
                                            VisibleIndex="6">
                                            <HeaderStyle HorizontalAlign="Center" />
                                            <CellStyle HorizontalAlign="Center">
                                            </CellStyle>
                                        </dx:GridViewDataTextColumn>
                                    </Columns>
                                    <SettingsPager PageSize="20">
                                    </SettingsPager>
                                    <Images SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css">
                                        <LoadingPanelOnStatusBar Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                                        </LoadingPanelOnStatusBar>
                                        <LoadingPanel Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                                        </LoadingPanel>
                                    </Images>
                                    <ImagesFilterControl>
                                        <LoadingPanel Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                                        </LoadingPanel>
                                    </ImagesFilterControl>
                                    <Styles CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue">
                                        <Header ImageSpacing="5px" SortingImageSpacing="5px">
                                        </Header>
                                        <LoadingPanel ImageSpacing="5px">
                                        </LoadingPanel>
                                    </Styles>
                                    <StylesPager>
                                        <PageNumber ForeColor="#3E4846">
                                        </PageNumber>
                                        <Summary ForeColor="#1E395B">
                                        </Summary>
                                    </StylesPager>
                                    <StylesEditors ButtonEditCellSpacing="0">
                                        <ProgressBar Height="21px">
                                        </ProgressBar>
                                    </StylesEditors>
                                </dx:ASPxGridView>
                            </td>
                        </tr>
                    </table>
                    <dx:ASPxRoundPanel ID="RPFormula_A_B" runat="server" Width="70%" CssFilePath="~/App_Themes/Aqua/{0}/styles.css"
                        CssPostfix="Aqua" GroupBoxCaptionOffsetY="-28px" HeaderText="Formula para los artículos A y B"
                        SpriteCssFilePath="~/App_Themes/Aqua/{0}/sprite.css" View="GroupBox" ClientVisible="False"
                        ShowHeader="False" Theme="Metropolis">
                        <ContentPaddings Padding="0px" />
                        <ContentPaddings Padding="14px"></ContentPaddings>
                        <PanelCollection>
                            <dx:PanelContent runat="server" SupportsDisabledAttribute="True">
                                <table>
                                    <tr>
                                        <td class="filas2">
                                            <asp:Label ID="Label1" runat="server" Font-Names="Arial" Font-Size="10pt" ForeColor="#4FA7FF"
                                                Text="Periodo venta inicial" Font-Bold="True"></asp:Label>
                                            :&nbsp;
                                            <asp:Label ID="lblPerioinicial" runat="server" Font-Bold="True"></asp:Label>
                                            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                            <asp:Label ID="Label2" runat="server" Font-Names="Arial" Font-Size="10pt" ForeColor="#4FA7FF"
                                                Text="Periodo venta final" Font-Bold="True"></asp:Label>
                                            :&nbsp;&nbsp;&nbsp;
                                            <asp:Label ID="lblPeriodoFinal" runat="server" Font-Bold="True"></asp:Label>
                                        </td>
                                    </tr>
                                </table>
                                <table style="width: 100%;">
                                    <tr>
                                        <td class="filas2">
                                            &nbsp;
                                        </td>
                                        <td class="filas2">
                                            &nbsp;
                                        </td>
                                        <td class="filas2">
                                            &nbsp;
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="filas2" align="right">
                                            <asp:Label ID="Label4" runat="server" Text="Prom. sal. diarias (P.S.D) " BorderStyle="None"
                                                Font-Bold="True"></asp:Label>
                                        </td>
                                        <td class="filas2">
                                            :
                                        </td>
                                        <td class="filas2">
                                            (cantidad venta / número meses /días)
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="filas2" align="right">
                                            <asp:Label ID="lblTotalPromedioDias" runat="server" BorderStyle="None" Font-Bold="True"> </asp:Label>
                                        </td>
                                        <td class="filas2">
                                            :
                                        </td>
                                        <td class="filas2" align="left">
                                            (
                                            <asp:Label ID="lblTotalCan" runat="server"></asp:Label>
                                            &nbsp;/
                                            <asp:Label ID="lblMax" runat="server"></asp:Label>
                                            /
                                            <asp:Label ID="lblDias" runat="server" Text="30"></asp:Label>
                                            &nbsp;)
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="filas2">
                                            &nbsp;
                                        </td>
                                        <td class="filas2">
                                            &nbsp;
                                        </td>
                                        <td class="filas2">
                                            &nbsp;
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="filas2" style="height: 34px" align="right">
                                            <asp:Label ID="Label5" runat="server" Text="Prom.sal.mensual (P.S.M)" BorderStyle="None"
                                                Font-Bold="True"></asp:Label>
                                        </td>
                                        <td class="filas2" style="height: 34px">
                                            :
                                        </td>
                                        <td class="filas2" style="height: 34px" align="left">
                                            (Cantidad venta ) / número meses
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="filas2" align="right">
                                            <asp:Label ID="lblPSM" runat="server" Font-Bold="True"></asp:Label>
                                        </td>
                                        <td class="filas2">
                                            :
                                        </td>
                                        <td class="filas2" align="left">
                                            <asp:Label ID="lblPSMcantidad" runat="server"></asp:Label>
                                            /
                                            <asp:Label ID="lblNumeroMeses" runat="server"></asp:Label>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="filas2">
                                            &nbsp;
                                        </td>
                                        <td class="filas2">
                                            :
                                        </td>
                                        <td class="filas2">
                                            &nbsp;
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="filas2" align="right">
                                            <asp:Label ID="Label6" runat="server" Text="Cantidad sugerida" BorderStyle="None"
                                                Font-Bold="True"></asp:Label>
                                        </td>
                                        <td class="filas2">
                                            :
                                        </td>
                                        <td class="filas2">
                                            (P.S.D * nro.dias reposición) - cantidad stock - cantidad tránsito
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="filas2" align="right">
                                            <dx:ASPxLabel ID="lblCantidadSugerida" runat="server" Font-Bold="True">
                                            </dx:ASPxLabel>
                                        </td>
                                        <td class="filas2">
                                            :
                                        </td>
                                        <td class="filas2" align="left">
                                            (<dx:ASPxLabel ID="lblPSD" runat="server">
                                            </dx:ASPxLabel>
                                            *
                                            <dx:ASPxLabel ID="lblPeriodosSalidaStock" runat="server">
                                            </dx:ASPxLabel>
                                            )-
                                            <dx:ASPxLabel ID="lblCantidadStock" runat="server">
                                            </dx:ASPxLabel>
                                            -
                                            <dx:ASPxLabel ID="lblCantidadTransito" runat="server">
                                            </dx:ASPxLabel>
                                        </td>
                                    </tr>
                                </table>
                            </dx:PanelContent>
                        </PanelCollection>
                    </dx:ASPxRoundPanel>
                    <br />
                    <dx:ASPxRoundPanel ID="RPFormula_C_N_O" runat="server" Width="75%" CssFilePath="~/App_Themes/Aqua/{0}/styles.css"
                        CssPostfix="Aqua" GroupBoxCaptionOffsetY="-28px" HeaderText=""
                        SpriteCssFilePath="~/App_Themes/Aqua/{0}/sprite.css" View="GroupBox" ClientVisible="False"
                        Theme="Metropolis">
                        <ContentPaddings Padding="0px" />
                        <ContentPaddings Padding="14px"></ContentPaddings>
                        <PanelCollection>
                            <dx:PanelContent ID="PanelContent3" runat="server" SupportsDisabledAttribute="True">
                                <table>
                                    <tr>
                                        <td class="filas2">
                                            <asp:Label ID="Label7" runat="server" ForeColor="#4FA7FF" 
                                                Text="Periodo venta inicial" Font-Bold="True" Font-Size="10pt"></asp:Label>
                                            &nbsp;:
                                            <asp:Label ID="Lsi" runat="server" Font-Bold="True"></asp:Label>
                                            &nbsp;&nbsp;&nbsp;&nbsp;
                                            <asp:Label ID="Label8" runat="server" ForeColor="#4FA7FF" 
                                                Text="Periodo venta final" Font-Bold="True" Font-Size="10pt"></asp:Label>
                                            :<asp:Label ID="lpf" runat="server" Font-Bold="True"></asp:Label>
                                        </td>
                                    </tr>
                                </table>
                                <table>
                                    <tr>
                                        <td class="filas2" align="right">
                                            <asp:Label ID="Label9" runat="server" Text="Periodo de salida stock" 
                                                Font-Bold="True"></asp:Label>
                                        </td>
                                        <td class="filas2">
                                            :
                                        </td>
                                        <td class="filas2" align="left">
                                            <asp:Label ID="ls" runat="server"></asp:Label>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="filas2">
                                            &nbsp;</td>
                                        <td class="filas2">
                                            &nbsp;</td>
                                        <td class="filas2">
                                            &nbsp;</td>
                                    </tr>
                                    <tr>
                                        <td class="filas2" align="right">
                                            <asp:Label ID="Label11" runat="server" Text="Prom. Sal. Diarias (P.S.D)" 
                                                Font-Bold="True"></asp:Label>
                                        </td>
                                        <td align="center">
                                            :
                                        </td>
                                        <td>
                                            (cantidad venta) /dias
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="filas2" align="right">
                                            <asp:Label ID="lblTotalCNO" runat="server" Font-Bold="True"></asp:Label>
                                        </td>
                                        <td align="center">
                                            :
                                        </td>
                                        <td>
                                            (<asp:Label ID="lblCant_vta" runat="server"></asp:Label>
                                            &nbsp;&nbsp;) /
                                            <asp:Label ID="lblNum_vta" runat="server"></asp:Label>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right" class="filas2">
                                            &nbsp;</td>
                                        <td align="center">
                                            &nbsp;</td>
                                        <td>
                                            &nbsp;</td>
                                    </tr>
                                    <tr>
                                        <td align="right" class="filas2">
                                            <asp:Label ID="Label12" runat="server" BorderStyle="None" Font-Bold="True" 
                                                Text="Prom.sal.mensual (P.S.M)"></asp:Label>
                                        </td>
                                        <td align="center">
                                            &nbsp;</td>
                                        <td>
                                            (Cantidad venta ) / número meses
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right" class="filas2">
                                            <asp:Label ID="lblPSM0" runat="server" Font-Bold="True"></asp:Label>
                                        </td>
                                        <td align="center">
                                            &nbsp;</td>
                                        <td>
                                            <asp:Label ID="lblPSMcantidad0" runat="server"></asp:Label>
                                            /&nbsp;<asp:Label ID="lblNumeroMeses0" runat="server"></asp:Label>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right" class="filas2">
                                            &nbsp;</td>
                                        <td align="center">
                                            &nbsp;</td>
                                        <td>
                                            &nbsp;</td>
                                    </tr>
                                    <tr>
                                        <td align="right" class="filas2">
                                            <asp:Label ID="Label13" runat="server" BorderStyle="None" Font-Bold="True" 
                                                Text="Cantidad sugerida"></asp:Label>
                                        </td>
                                        <td align="center">
                                            &nbsp;</td>
                                        <td>
                                            (P.S.D * nro.dias reposición) - cantidad stock - cantidad tránsito
                                        </td>
                                    </tr>
                                    <tr>
                                        <td align="right" class="filas2">
                                            <dx:ASPxLabel ID="lblCantidadSugerida0" runat="server" Font-Bold="True">
                                            </dx:ASPxLabel>
                                        </td>
                                        <td align="center">
                                            &nbsp;</td>
                                        <td>
                                            (<dx:ASPxLabel ID="lblPSD0" runat="server">
                                            </dx:ASPxLabel>
                                            *
                                            <dx:ASPxLabel ID="lblPeriodosSalidaStock0" runat="server">
                                            </dx:ASPxLabel>
                                            )-
                                            <dx:ASPxLabel ID="lblCantidadStock0" runat="server">
                                            </dx:ASPxLabel>
                                            -
                                            <dx:ASPxLabel ID="lblCantidadTransito0" runat="server">
                                            </dx:ASPxLabel>
                                        </td>
                                    </tr>
                                </table>
                            </dx:PanelContent>
                        </PanelCollection>
                    </dx:ASPxRoundPanel>
                </dx:PopupControlContentControl>
            </ContentCollection>
        </dx:ASPxPopupControl>
        <dx:ASPxPopupControl ID="popupReporte" runat="server" AllowDragging="True" CloseAction="CloseButton"
            ContentUrl="~/Repuestos/wFrmSituacionArticuloReport.aspx" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
            CssPostfix="Office2010Blue" HeaderText="Situación de Item" Height="700px" Modal="True"
            PopupHorizontalAlign="WindowCenter" PopupVerticalAlign="WindowCenter" ScrollBars="Both"
            SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css" Width="1300px"
            EnableHotTrack="False">
            <LoadingPanelImage Url="~/App_Themes/Office2010Blue/Web/Loading.gif">
            </LoadingPanelImage>
            <HeaderStyle>
                <Paddings PaddingLeft="7px" />
            </HeaderStyle>
            <LoadingPanelStyle ImageSpacing="5px">
            </LoadingPanelStyle>
            <ContentCollection>
                <dx:PopupControlContentControl runat="server" SupportsDisabledAttribute="True">
                </dx:PopupControlContentControl>
            </ContentCollection>
        </dx:ASPxPopupControl>
        <br />
        <br />
        <dx:ASPxPopupControl ID="PopupImportar" runat="server" Height="150px" Width="236px"
            ClientInstanceName="PopupImportar" AllowDragging="True" CloseAction="CloseButton"
            CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
            EnableViewState="False" HeaderText="Importar Archivo de Excel" Modal="True" PopupHorizontalAlign="WindowCenter"
            PopupVerticalAlign="WindowCenter" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
            EnableHotTrack="False">
            <LoadingPanelImage Url="~/App_Themes/Office2010Blue/Web/Loading.gif">
            </LoadingPanelImage>
            <HeaderStyle>
                <Paddings PaddingLeft="7px" />
            </HeaderStyle>
            <LoadingPanelStyle ImageSpacing="5px">
            </LoadingPanelStyle>
            <ContentCollection>
                <dx:PopupControlContentControl>
                    <dx:ASPxPanel ID="Panel2" runat="server" DefaultButton="btCreate">
                        <PanelCollection>
                            <dx:PanelContent runat="server">
                                <table cellpadding="0" cellspacing="0">
                                    <tr>
                                        <td>
                                            &nbsp;<dx:ASPxUploadControl ID="ucCargarExcel" runat="server" OnFileUploadComplete="ucCargarExcel_FileUploadComplete1"
                                                Width="280px" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
                                                SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css">
                                                <ValidationSettings FileDoesNotExistErrorText="La archivo a cargar no existe" GeneralErrorText="La carga del archivo falla debido a un error externo que no está relacionado con la funcionalidad del control."
                                                    MaxFileSizeErrorText="El tamaño del archivo excede el tamaño máximo permitido, que es {0} bytes"
                                                    MultiSelectionErrorText="Attention! 

The following {0} files are invalid because they exceed the allowed file size ({1}) or their extensions are not allowed. These files have been removed from selection, so they will not be uploaded. 

{2}" NotAllowedContentTypeErrorText="Este tipo de contenido no está permitido" NotAllowedFileExtensionErrorText="Esta extensión de archivo no está permitida">
                                                </ValidationSettings>
                                            </dx:ASPxUploadControl>
                                        </td>
                                    </tr>
                                </table>
                                <table>
                                    <tr>
                                        <td>
                                            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                            &nbsp;
                                        </td>
                                        <td>
                                            <dx:ASPxButton ID="btAceptar" runat="server" OnClick="btAceptar_Click" Text="Importar"
                                                CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
                                                SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css" Width="10px" AutoPostBack="False">
                                                <ClientSideEvents Click="function(s, e) {
    PopupImportar.Hide();
	e.processOnServer = true;
}" />
                                            </dx:ASPxButton>
                                        </td>
                                        <td>
                                            <dx:ASPxButton ID="btnCancelar" runat="server" AutoPostBack="False" ClientInstanceName="btnCancelar"
                                                Text="Cancelar" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
                                                SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css" Width="10px">
                                                <ClientSideEvents Click="function(s, e) {
	PopupImportar.Hide();
}" />
                                            </dx:ASPxButton>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td colspan="3">
                                            &nbsp;
                                        </td>
                                    </tr>
                                </table>
                            </dx:PanelContent>
                        </PanelCollection>
                    </dx:ASPxPanel>
                </dx:PopupControlContentControl>
            </ContentCollection>
        </dx:ASPxPopupControl>
        <br />
        <dx:ASPxPopupControl ID="PC_ImportarArticulos" runat="server" ClientInstanceName="PC_ImportarArticulos"
            CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
            HeaderText="" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
            AllowDragging="True" Modal="True" PopupHorizontalAlign="WindowCenter" PopupVerticalAlign="WindowCenter"
            EnableHotTrack="False">
            <LoadingPanelImage Url="~/App_Themes/Office2010Blue/Web/Loading.gif">
            </LoadingPanelImage>
            <HeaderStyle>
                <Paddings PaddingLeft="7px" />
            </HeaderStyle>
            <LoadingPanelStyle ImageSpacing="5px">
            </LoadingPanelStyle>
            <ContentCollection>
                <dx:PopupControlContentControl runat="server" SupportsDisabledAttribute="True">
                    <dx:ASPxRoundPanel ID="RP_ImportarArticulos" runat="server" Width="200px" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                        CssPostfix="Office2010Blue" EnableDefaultAppearance="False" GroupBoxCaptionOffsetX="6px"
                        GroupBoxCaptionOffsetY="-19px" HeaderText="Seleccione un archivo Excel" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css">
                        <ContentPaddings PaddingBottom="10px" PaddingLeft="9px" PaddingRight="11px" PaddingTop="10px" />
                        <HeaderStyle>
                            <Paddings PaddingBottom="6px" PaddingLeft="9px" PaddingRight="11px" PaddingTop="3px" />
                        </HeaderStyle>
                        <PanelCollection>
                            <dx:PanelContent runat="server" SupportsDisabledAttribute="True">
                                <table>
                                    <tr>
                                        <td class="filas">
                                            <dx:ASPxButton ID="btnDescargarFormato" runat="server" Text="Descargar formato excel"
                                                CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
                                                OnClick="btnDescargarFormato_Click" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                                                Width="200px">
                                            </dx:ASPxButton>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td class="filas">
                                            <dx:ASPxUploadControl ID="UC_ImportarArticulos" runat="server" Width="350px" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                                                CssPostfix="Office2010Blue" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                                                OnFileUploadComplete="UC_ImportarArticulos_FileUploadComplete" ClientInstanceName="importarArticulos"
                                                AddUploadButtonsHorizontalPosition="Center">
                                                <ValidationSettings MultiSelectionErrorText="Attention! 

The following {0} files are invalid because they exceed the allowed file size ({1}) or their extensions are not allowed. These files have been removed from selection, so they will not be uploaded. 

{2}" AllowedFileExtensions=".xls, .xlsx, .txt, .csv">
                                                </ValidationSettings>
                                            </dx:ASPxUploadControl>
                                        </td>
                                    </tr>
                                </table>
                                <table>
                                    <tr>
                                        <td>
                                            <dx:ASPxButton ID="POP_btnImportarArticulos" runat="server" Text="Importar" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                                                CssPostfix="Office2010Blue" OnClick="POP_btnImportarArticulos_Click" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                                                Width="100px" AutoPostBack="False">
                                                <ClientSideEvents Click="function(s, e) {
	PC_ImportarArticulos.Hide();
}" />
                                            </dx:ASPxButton>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            &nbsp;
                                        </td>
                                        <td>
                                            &nbsp;
                                        </td>
                                    </tr>
                                    <tr>
                                        <dx:ASPxGridView ID="grdDatosArticulosImportados" runat="server" AutoGenerateColumns="False"
                                            CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
                                            Width="100%" ClientVisible="False">
                                            <TotalSummary>
                                                <dx:ASPxSummaryItem FieldName="Total" SummaryType="Sum" />
                                            </TotalSummary>
                                            <Columns>
                                                <dx:GridViewDataTextColumn FieldName="Codigo" ShowInCustomizationForm="True" VisibleIndex="0">
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="Descripcion" ShowInCustomizationForm="True"
                                                    VisibleIndex="1">
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="Cantidad" ShowInCustomizationForm="True" VisibleIndex="2">
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="FOB_UNIT" ShowInCustomizationForm="True" VisibleIndex="3">
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="Total" ShowInCustomizationForm="True" UnboundType="Decimal"
                                                    VisibleIndex="4">
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="Caja" ShowInCustomizationForm="True" VisibleIndex="5">
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn Caption="Tipo" FieldName="TIPO_PRONOSTICO" ShowInCustomizationForm="True"
                                                    VisibleIndex="6">
                                                </dx:GridViewDataTextColumn>
                                            </Columns>
                                            <SettingsPager PageSize="1000">
                                            </SettingsPager>
                                            <Settings ShowFooter="True" />
                                            <Images SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css">
                                                <LoadingPanelOnStatusBar Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                                                </LoadingPanelOnStatusBar>
                                                <LoadingPanel Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                                                </LoadingPanel>
                                            </Images>
                                            <ImagesFilterControl>
                                                <LoadingPanel Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                                                </LoadingPanel>
                                            </ImagesFilterControl>
                                            <Styles CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue">
                                                <Header ImageSpacing="5px" SortingImageSpacing="5px">
                                                </Header>
                                                <LoadingPanel ImageSpacing="5px">
                                                </LoadingPanel>
                                            </Styles>
                                            <StylesPager>
                                                <PageNumber ForeColor="#3E4846">
                                                </PageNumber>
                                                <Summary ForeColor="#1E395B">
                                                </Summary>
                                            </StylesPager>
                                            <StylesEditors ButtonEditCellSpacing="0">
                                                <ProgressBar Height="21px">
                                                </ProgressBar>
                                            </StylesEditors>
                                        </dx:ASPxGridView>
                                    </tr>
                                    <tr>
                                        <td>
                                            &nbsp;
                                        </td>
                                    </tr>
                                </table>
                            </dx:PanelContent>
                        </PanelCollection>
                    </dx:ASPxRoundPanel>
                </dx:PopupControlContentControl>
            </ContentCollection>
        </dx:ASPxPopupControl>
        <asp:UpdatePanel runat="server">
            <ContentTemplate>
                <dx:ASPxPopupControl ID="PopupMSJGeneral" runat="server" AllowDragging="True" ClientInstanceName="PopupMSJGeneral"
                    CloseAction="None" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
                    EnableViewState="False" HeaderText="Mensaje" Modal="True" PopupHorizontalAlign="WindowCenter"
                    PopupVerticalAlign="WindowCenter" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                    Width="300px" EnableHotTrack="False">
                    <LoadingPanelImage Url="~/App_Themes/Office2010Blue/Web/Loading.gif">
                    </LoadingPanelImage>
                    <HeaderStyle>
                        <Paddings PaddingBottom="4px" PaddingLeft="10px" PaddingRight="4px" PaddingTop="4px" />
                        <Paddings PaddingLeft="7px"></Paddings>
                    </HeaderStyle>
                    <LoadingPanelStyle ImageSpacing="5px">
                    </LoadingPanelStyle>
                    <ContentCollection>
                        <dx:PopupControlContentControl ID="PopupControlContentControl3" runat="server" SupportsDisabledAttribute="True">
                            <br />
                            <dx:ASPxPanel ID="ASPxPanel5" runat="server" DefaultButton="btCreate">
                                <PanelCollection>
                                    <dx:PanelContent ID="PanelContent4" runat="server">
                                        <table align="center">
                                            <tr>
                                                <td class="filas">
                                                    <dx:ASPxLabel ID="lblmsj" runat="server" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                                                        CssPostfix="Office2010Blue">
                                                    </dx:ASPxLabel>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="filas">
                                                    <dx:ASPxLabel ID="lblMsjDetalleRegistro" runat="server" ClientVisible="False">
                                                    </dx:ASPxLabel>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="filas">
                                                    &nbsp;
                                                    <dx:ASPxHyperLink ID="hplArticulosNoRegistrado" runat="server" Text="Ver artículos no registrados"
                                                        ClientVisible="False" Cursor="pointer" Font-Names="Aharoni" Font-Size="11pt"
                                                        Font-Underline="True" ForeColor="#000099">
                                                        <ClientSideEvents Click="function(s, e) {
	MostrarDatos();
}" />
                                                    </dx:ASPxHyperLink>
                                                </td>
                                            </tr>
                                        </table>
                                        <table align="center">
                                            <tr>
                                                <td align="center" style="width: 215px">
                                                    <dx:ASPxButton ID="ASPxButton4" runat="server" Text="Aceptar" AutoPostBack="False"
                                                        CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
                                                        SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css">
                                                        <ClientSideEvents Click="function(s, e) {
	PopupMSJGeneral.Hide();
}" />
                                                    </dx:ASPxButton>
                                                </td>
                                            </tr>
                                        </table>
                                    </dx:PanelContent>
                                </PanelCollection>
                            </dx:ASPxPanel>
                        </dx:PopupControlContentControl>
                    </ContentCollection>
                </dx:ASPxPopupControl>
            </ContentTemplate>
        </asp:UpdatePanel>
        <asp:GridView ID="grdListaHerramientas" runat="server" 
            AutoGenerateColumns="False" Visible="False">
            <Columns>
                <asp:BoundField DataField="COD_MATERIAL" HeaderText="CODE" />
                <asp:BoundField DataField="DES_MATERIAL" HeaderText="DESCRIPTION" />
                <asp:BoundField DataField="cant_sug_real" DataFormatString="{0:N0}" 
                    HeaderText="Qty" />
            </Columns>
        </asp:GridView>
        <br />
        <asp:GridView ID="grdListaRepuestos" runat="server" AutoGenerateColumns="False" 
            Visible="False">
            <Columns>
                <asp:BoundField DataField="COD_MATERIAL" HeaderText="CODE" />
                <asp:BoundField DataField="DES_MATERIAL" HeaderText="DESCRIPTION" />
                <asp:BoundField DataField="cant_sug_real" DataFormatString="{0:N0}" 
                    HeaderText="Qty" />
            </Columns>
        </asp:GridView>
        <br />
        <dx:ASPxGridView ID="grdDatosNoRegistrados" runat="server" AutoGenerateColumns="False"
            ClientVisible="False" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
            CssPostfix="Office2010Blue" KeyFieldName="cod_material" ClientInstanceName="Articulos No Registrados">
            <Columns>
                <dx:GridViewDataTextColumn Caption="CODIGO" FieldName="cod_material" VisibleIndex="0"
                    Width="100px">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn Caption="DESCRIPCION" FieldName="descripcion" VisibleIndex="1"
                    Width="350px">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="cantidad" VisibleIndex="2" Width="50px">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="fob_unit" VisibleIndex="3" Width="50px">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="caja" VisibleIndex="4" Width="100px">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="tipo_pronostico" VisibleIndex="5" Width="100px">
                </dx:GridViewDataTextColumn>
            </Columns>
            <SettingsPager PageSize="1000">
            </SettingsPager>
            <Images SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css">
                <LoadingPanelOnStatusBar Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                </LoadingPanelOnStatusBar>
                <LoadingPanel Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                </LoadingPanel>
            </Images>
            <ImagesFilterControl>
                <LoadingPanel Url="~/App_Themes/Office2010Blue/GridView/Loading.gif">
                </LoadingPanel>
            </ImagesFilterControl>
            <Styles CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue">
                <Header ImageSpacing="5px" SortingImageSpacing="5px">
                </Header>
                <LoadingPanel ImageSpacing="5px">
                </LoadingPanel>
            </Styles>
            <StylesPager>
                <PageNumber ForeColor="#3E4846">
                </PageNumber>
                <Summary ForeColor="#1E395B">
                </Summary>
            </StylesPager>
            <StylesEditors ButtonEditCellSpacing="0">
                <ProgressBar Height="21px">
                </ProgressBar>
            </StylesEditors>
        </dx:ASPxGridView>
        <br />
        <dx:ASPxButton ID="btnVerDetalle" runat="server" OnClick="btnDetalle_Click" ClientVisible="false"
            ClientInstanceName="btnVerDetalle" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
            CssPostfix="Office2010Blue" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
            Width="1px">
        </dx:ASPxButton>
        <br />
        <dx:ASPxPopupControl ID="pcPedidoImportacion" runat="server" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
            CssPostfix="Office2010Blue" EnableHotTrack="False" HeaderText="Vista Previa"
            Height="520px" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
            Width="900px" AllowDragging="True" ClientInstanceName="pcPedidoImportacion" PopupHorizontalAlign="WindowCenter"
            PopupVerticalAlign="WindowCenter">
            <LoadingPanelImage Url="~/App_Themes/Office2010Blue/Web/Loading.gif">
            </LoadingPanelImage>
            <HeaderStyle>
                <Paddings PaddingLeft="7px" />
            </HeaderStyle>
            <LoadingPanelStyle ImageSpacing="5px">
            </LoadingPanelStyle>
            <ContentCollection>
                <dx:PopupControlContentControl runat="server" SupportsDisabledAttribute="True">
                    <rsweb:ReportViewer ID="rvPopupReporte" runat="server" BackColor="#F2F2F2" Font-Names="Verdana"
                        Font-Size="8pt" Height="490px" InteractiveDeviceInfos="(Collection)" KeepSessionAlive="False"
                        SplitterBackColor="White" Style="padding-top: 0; margin-top: 0; top: 0; vertical-align: top"
                        WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="100%">
                    </rsweb:ReportViewer>
                </dx:PopupControlContentControl>
            </ContentCollection>
        </dx:ASPxPopupControl>
        <br />
        <br />
        <dx:ASPxGridViewExporter ID="gvExporterRepuestos" runat="server" GridViewID="grdListaRepuestos">
            <PageHeader VerticalAlignment="None">
            </PageHeader>
            <PageFooter VerticalAlignment="None">
            </PageFooter>
        </dx:ASPxGridViewExporter>
        <br />
        <dx:ASPxGridViewExporter ID="gvExporterHerramientas" runat="server" GridViewID="grdListaHerramientas"
            PaperName="Tools">
            <PageHeader VerticalAlignment="None">
            </PageHeader>
            <PageFooter VerticalAlignment="None">
            </PageFooter>
        </dx:ASPxGridViewExporter>
        <br />
        <dx:ASPxGridViewExporter ID="gvExporterArticulosNoRegistrados" runat="server" FileName="cod_material"
            GridViewID="grdDatosNoRegistrados">
        </dx:ASPxGridViewExporter>
    </div>
</asp:Content>
